Grow Your IT & Business Skills & Get Certified

VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft® Excel® and other applications in the Microsoft® Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users

This five-day course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing storage and compute by using Windows Server, and who need to understand the scenarios, requirements, and storage and compute options that are available and applicable to Windows Server. Although this course and the associated labs are written for Windows Server 2022, the skills taught will also be backwards compatible for Server 2016 and Server 2019. The course and labs also focus on how to administer Windows Server using not only the traditional tools such as PowerShell and Server manager, but also Windows Admin Center.

This course covers network defense and incident response methods, tactics, and procedures that are in alignment with industry frameworks such as NIST 800-61r2 (Computer Security Incident Handling Guide), US-CERT's National Cyber Incident Response Plan (NCIRP), and Presidential Policy Directive (PPD)-41 on Cyber Incident Coordination, NIST 800.171r2 (Protecting Controlled Unclassified Information in Nonfederal Systems and Organizations). It is ideal for candidates who have been tasked with the responsibility of monitoring and detecting security incidents in information systems and networks, and for executing standardized responses to such incidents. The course introduces tools, tactics, and procedures to manage cybersecurity risks, defend cybersecurity assets, identify various types of common threats, evaluate the organization's security, collect and analyze cybersecurity intelligence, and remediate and report incidents as they occur. This course provides a comprehensive methodology for individuals responsible for defending the cybersecurity of their organization.This course is designed to assist students in preparing for the CertNexus CyberSec First Responder (Exam CFR-410) certification examination. What you learn and practice in this course can be a significant part of your preparation.Purchase of this course includes the associated exam voucher.

Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft® Excel® can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation. Note: Most Office 365™ users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Office 365 subscription. This includes brief coverage of key skills for using Excel for the Web and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version. This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2019): Exam MO-200 and Excel Expert (Office 365 and Office 2019): Exam MO-201.

Adobe® Photoshop® CC (2019): Part 1 focuses on some of the basic features of Photoshop so that the student can navigate the environment and use Photoshop tools to work with photographic images. In addition, the orientation to Adobe® Bridge and organization of files in Bridge is covered. Although Photoshop is used by a variety of professionals, from photographers to designers to videographers, Photoshop Part 1 will focus mainly on the photography component. The illustration and animation techniques are covered in subsequent levels of Photoshop. This course is a great component of your preparation for the Adobe Certified Expert (ACE): Photoshop CC exam and the Adobe Certified Associate (ACA) Visual Communication Using Adobe Photoshop CC exam.

In the interdependent workplace, we rely on each other to get things done. A professional network isn’t something we can take for granted – mapping work relationships can be a complex task and understanding different behavioral styles takes effort - but it pays off! Good working relationships means more than just reducing conflict and misunderstandings. It also means building trust, increasing influence, and benefitting from the knowledge and advice of co-workers and senior managers. This workshop will help you develop relationship building skills so you can communicate who you are, what you need, and why you need it in a way that builds trust, respect, and a professional reputation. Private classes on this topic are available. We can address your organization’s issues, time constraints, and save you money, too. Contact us to find out how.

Success is measured by results and results are only accomplished with effective planning efforts. Detailed plans and a captivating vision are important, but true accomplishment is in carrying your goals through to a winning outcome. In this workshop, you will learn how to find and strengthen your leadership voice and foster employee buy-in to exceed expectations while achieving the most positive outcome. Private classes on this topic are available. We can address your organization’s issues, time constraints, and save you money, too. Contact us to find out how.

In this course, you will build upon the foundational and intermediate knowledge presented in the Microsoft Excel - Part 1 and Microsoft Excel - Part 2 courses to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates.

The Official CompTIA® Linux+® courseware builds on your existing experience with systems operations and administration to provide you with the knowledge and skills required to configure, manage, operate, and troubleshoot a Linux environment by using security best practices, scripting, and automation. This course will also prepare you for the Exam XKO-005.

This course teaches IT Professionals how to manage core Windows Server workloads and services using on-premises, hybrid, and cloud technologies. The course teaches IT Professionals how to implement and manage on-premises and hybrid solutions such as identity, management, compute, networking, and storage in a Windows Server hybrid environment.

Design secure cloud solutions to data management with AWS Architecting. Learn how to design and build scalable solutions, as well as best practices and optimization recommendations with our AWS Architecting training courses.

Our AWS Developer training courses ensure you have the skills to succeed, both on the exam and in a professional environment. Learn how to configure SDKs and IDE toolkits and understand Deep Learning models.

Use this journey to develop your skills to build simple reports to complex reports, and learn how to create active reports which are available offline from the enterprise data source.

Use this journey to develop your skills in designing models using OLAP cubes, Dynamic Cubes, or relational data sources, and continue your development to design Scorecards.

Mainframe Application Developers create and support computer code used in the organization’s mainframe systems to perform business functions. This includes assisting with the design, coding, and testing of computer programs, analyzing and resolving programming issues, and supporting the business to ensure application programs work as required. Mainframe Application Developers are found in a variety of industries including but not limited to Health Care, Insurance, Retail, Transportation, etc.

System/Computer Operators oversee the systems ensuring all computers are running correctly. This role monitors and controls system console messages, processes and resolves job processing problems performs system backups, maintains peripheral devices, and performs disaster recovery procedures. This role commonly functions within a Data Center.

Systems Programmers program computer system software, including, but not limited to installing and maintaining the system software, managing the installation, performing overall maintenance, tuning, and resolving problems regarding the operating system. The systems programmer provides software and software platforms and administers IBM Mainframes.

ITIL® 4 Foundation introduces the management of modern IT-enabled services, to provide an understanding of the common language and key concepts, and to show how organizations and work can improve with the ITIL® 4 guidance.

Get an introduction to the key principles of service strategy, and learn about the service strategy processes. Discover the importance of governance and related frameworks, and examine implementation considerations and approaches, including organizational design, the role of technology, and service automation.

With LearnQuest's Core Java Curriculum, you'll build your core java skills including Micro Services, REST, and database access. Then you can choose the Spring Framework and/or Web Development Learning Journeys to continue building your skills.